# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2021年10月12日
"""
import pandas as pd

path = '../数据文件/课件021/替换.xlsx'

data = pd.read_excel(path)

# data['城市2'] = data['城市2'].str.replace('城八区', '市区')
data.replace('[A-Z]', 88, regex=True, inplace=True)
print(data)
# print(data1)